/*
Navicat SQL Server Data Transfer

Source Server         : CMRS Staging
Source Server Version : 105000
Source Host           : 74.208.104.19:1433
Source Database       : cmrsfinal
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 105000
File Encoding         : 65001

Date: 2012-04-04 17:35:18
*/

-- ----------------------------
-- Records of userpreference
-- ----------------------------
SET IDENTITY_INSERT [userpreference] ON
GO
INSERT INTO [userpreference] ([id], [aadateid], [aaid], [cndateid], [cnid], [pmasignid], [pmreagionid], [paymentasignid], [pgasignid], [pgreagionid]) VALUES ('1', '1', null, '3', null, null, null, null, null, null);
INSERT INTO [userpreference] ([id], [aadateid], [aaid], [cndateid], [cnid], [pmasignid], [pmreagionid], [paymentasignid], [pgasignid], [pgreagionid]) VALUES ('2', '1', '12', null, null, null, null, null, null, null);
INSERT INTO [userpreference] ([id], [aadateid], [aaid], [cndateid], [cnid], [pmasignid], [pmreagionid], [paymentasignid], [pgasignid], [pgreagionid]) VALUES ('3', '1', null, '2', null, null, null, null, null, null);
INSERT INTO [userpreference] ([id], [aadateid], [aaid], [cndateid], [cnid], [pmasignid], [pmreagionid], [paymentasignid], [pgasignid], [pgreagionid]) VALUES ('4', null, null, '1', '1', null, null, null, null, null);
INSERT INTO [userpreference] ([id], [aadateid], [aaid], [cndateid], [cnid], [pmasignid], [pmreagionid], [paymentasignid], [pgasignid], [pgreagionid]) VALUES ('5', '1', null, null, null, null, null, null, null, null);
INSERT INTO [userpreference] ([id], [aadateid], [aaid], [cndateid], [cnid], [pmasignid], [pmreagionid], [paymentasignid], [pgasignid], [pgreagionid]) VALUES ('6', null, null, null, null, '26', null, '26', '26', null);
GO
SET IDENTITY_INSERT [userpreference] OFF
GO

-- ----------------------------
-- Records of userinfo
-- ----------------------------
SET IDENTITY_INSERT [userinfo] ON
GO
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('211', '9F86D081884C7D659A2FEAA0C55AD015A3BF4F1B2B0B822CD15D6C15B0F00A08', 'TTempInfoOfficer', 'Temp', null, 'TempInfoOfficer', null, null, null, '1155', null, '2012-09-15 00:00:00.000', '0', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, '3');
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('1', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'DWatkins', 'Dennis', null, 'Watkins', 'dwatkins@cipe.org', null, null, '0927', '2003-08-08 00:00:00.000', '2003-01-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('2', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'KBrunson', 'Karen', null, 'Brunson', 'kbrunson@cipe.org', null, null, '0933', '2008-03-12 00:00:00.000', '1998-05-18 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('3', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'AShkolnikov', 'Aleksandr', null, 'Shkolnikov', 'ashkolnikov@cipe.org', null, null, '5718', null, '2003-01-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('5', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'TDonohue', 'Thomas J.', null, 'Donohue', null, null, null, null, null, '2003-01-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('6', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'WWorkman', 'Williard A.', null, 'Workman', null, null, null, null, '2004-02-04 00:00:00.000', '2003-01-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('7', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'JSullivan', 'John D.', null, 'Sullivan', 'jdsullivan@cipe.org', null, null, '0916', null, '2003-01-01 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('9', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'JCallebaut', 'John', null, 'Callebaut', 'johncall@cipe.org', null, null, '0949', null, '2003-01-01 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('10', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'SBunting-Graden', 'Syldeline', null, 'Bunting-Graden', 'sdecker@cipe.org', null, null, '0935', null, '1998-08-01 00:00:00.000', '0', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('11', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'KMoller', 'Kara E.', null, 'Moller', 'kmoller@cipe.org', null, null, '0926', '2005-05-27 00:00:00.000', '2003-01-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('12', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'NNadal', 'Nick', null, 'Nadal', 'nnadal@cipe.org', null, null, '0924', null, '2003-01-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, '1');
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('13', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'JRogers', 'Jean', null, 'Rogers', 'jrogers@cipe.org', null, null, '0920', null, '2003-01-01 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('14', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'SRogers', 'Steven B.', null, 'Rogers', 'srogers@cipe.org', null, null, '0914', null, '1986-01-01 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('15', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'RSaakian', 'Robyn', null, 'Saakian', 'realy@cipe.org', null, null, '0930', '2004-07-16 00:00:00.000', '2003-01-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('17', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'AWilson', 'Andrew', null, 'Wilson', 'awilson@cipe.org', null, null, '0923', null, '2003-01-01 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('18', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'JZemko', 'John', null, 'Zemko', 'jzemko@cipe.org', null, null, '0917', null, '2003-01-01 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('19', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'CKuchta-Helbling', 'Catherine', null, 'Kuchta-Helbling', 'ckhelbling@cipe.org', null, null, '0945', '2003-08-20 00:00:00.000', '2003-01-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('20', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'KKampmann', 'Katie', null, 'Kampmann', 'kkampmann@cipe.org', null, null, '0997', null, '2003-01-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('21', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'MMcCord', 'Mark', null, 'McCord', 'Mmccord@cipe.org', null, null, '4243', '2007-07-02 00:00:00.000', '2003-01-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('22', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'TMottley', 'Tamera', null, 'Mottley', 'tmottley@cipe.org', null, null, '5387', '2008-03-12 00:00:00.000', '2003-01-01 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('23', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'OYoon', 'Oksana', null, 'Yoon', 'oyoon@cipe.org', null, null, '5437', null, '2003-01-01 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, '4');
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('24', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'JAmselle', 'Jorge', null, 'Amselle', null, null, null, null, null, '2003-01-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('25', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'DRiedel', 'Durwood', null, 'Riedel', 'driedel@cipe.org', null, null, '5597', '2003-06-13 00:00:00.000', '2003-01-01 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('26', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'ESuhir', 'Elena', null, 'Suhir', 'esuhir@cipe.org', null, null, '5568', null, '2003-01-01 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, '6');
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('27', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'SCutler', 'Suzanne', null, 'Cutler', 'scutler@cipe.org', null, null, '5673', null, '2006-09-12 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('28', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'EStuart', 'Elisabeth', null, 'Stuart', 'estuart@cipe.org', null, null, '5686', '2004-08-03 00:00:00.000', '2003-01-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('30', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'ALiss', 'Alexander', null, 'Liss', 'aliss@cipe.org', null, null, '5712', '2004-12-03 00:00:00.000', '2003-01-01 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('31', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'VZunino', 'Veronica', null, 'Zunino', 'vzunino@cipe.org', null, null, '5757', '2004-08-27 00:00:00.000', '2003-01-01 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('32', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'KReznik', 'Kirill', null, 'Reznik', 'kreznik@cipe.org', null, null, '5864', '2004-08-12 00:00:00.000', '2003-01-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('33', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'RMarlatt', 'Ralph', null, 'Marlatt', 'Rmarlatt@cg.yu', null, null, '5554', null, '2003-01-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('34', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'DSouthworth', 'Dana', null, 'Southworth', 'dsouthworth@cipe.org', null, null, '0942', '2004-09-29 00:00:00.000', '2003-01-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('35', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'SOlsten', 'Sarah', null, 'Olsten', 'solsten@cipe.org', null, null, '5971', '2004-07-15 00:00:00.000', '2003-01-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('36', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'ZKovach', 'Zlatko', null, 'Kovach', 'zkovach@cipe.org', null, null, '5980', null, '2003-04-14 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('37', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'STauber', 'Stepan', null, 'Tauber', 'stauber@cipe.org', null, null, '5979', '2006-08-09 00:00:00.000', '2003-04-14 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('38', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'RSicotte', 'Robert', null, 'Sicotte', 'rsicotte@cipe.org', null, null, '5591', null, '2003-01-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('39', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'SJin', 'Sung', null, 'Jin', null, null, null, null, null, '2003-01-01 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('40', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'LCosta', 'Lynn', null, 'Costa', null, null, null, null, null, '2003-01-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('41', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'RAl-Zoghbi', 'Randa', null, 'Al-Zoghbi', 'Rzoghbi@cipe.org', null, null, null, null, '2012-01-01 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('42', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'MHassan', 'Mohamed', null, 'Hassan', null, null, null, null, null, '2003-01-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('43', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'ARaevsky', 'Alexander', null, 'Raevsky', null, null, null, null, null, '2003-01-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('44', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'DClement', 'Dan', null, 'Clement', null, null, null, null, null, '2003-01-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('45', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'CBulat', 'Camelia', null, 'Bulat', null, null, null, null, null, '2003-01-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('46', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'CGrecu', 'Cristina', null, 'Grecu', null, null, null, null, null, '2003-01-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('47', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'CStanila', 'Carmen', null, 'Stanila', null, null, null, null, null, '2003-01-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('48', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'CSchwartz', 'Corina', null, 'Schwartz', null, null, null, null, null, '2003-01-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('49', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'JVan Ness', 'Jeffrey', null, 'Van Ness', 'jvanness@cipe.org', null, null, '6130', '2005-02-25 00:00:00.000', '2003-06-16 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('50', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'FZora', 'Firend', null, 'Zora', 'fzora@cipe.org', null, null, '6172', '2004-08-27 00:00:00.000', '2003-07-07 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('51', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'NMalikova', 'Nigina', null, 'Malikova', 'nmalikova@cipe.org', null, null, '6187', null, '2003-07-10 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('52', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'LHaylett', 'Lascelles', null, 'Haylett', 'lhaylett@cipe.org', null, null, '6283', null, '2003-09-02 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('53', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'CGlover', 'Cathleen', null, 'Glover', 'cglover@cipe.org', null, null, '6400', null, '2003-11-10 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('54', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'GAdair', 'George', null, 'Adair', 'gadair@cipe.org', null, null, '6568', null, '2004-03-18 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('55', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'LBlanton', 'Laurie', null, 'Blanton', 'lblanton@cipe.org', null, null, '6592', '2004-10-15 00:00:00.000', '2004-04-28 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('56', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'SHutchison', 'Sarah E.', null, 'Hutchison', 'shutchison@cipe.org', null, null, '6670', '2005-03-02 00:00:00.000', '2004-06-09 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('57', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'RKraemer', 'Richard', null, 'Kraemer', 'Rkraemer@cipe.org', null, null, '6718', '2008-06-13 00:00:00.000', '2004-07-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('58', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'AFahmy', 'Amina', null, 'Fahmy', 'afahmy@cipe.org', null, null, '6757', '2005-06-17 00:00:00.000', '2004-07-16 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('59', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'BBaharova', 'Bistra', null, 'Baharova', 'Bbaharova@cipe.org', null, null, '6808', '2005-02-25 00:00:00.000', '2004-08-18 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('60', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'PTietjen', 'Peter', null, 'Tietjen', 'Ptietjen@cipe.org', null, null, '0922', '2008-03-12 00:00:00.000', '2004-09-27 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('61', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'KKahn', 'Karen', null, 'Kahn', 'kkahn@cipe.org', null, null, '6904', '2006-08-22 00:00:00.000', '2004-10-04 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('62', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'MFriedl', 'Martin', null, 'Friedl', 'mfriedl@cipe.org', null, null, '6910', null, '2004-10-12 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('63', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'SAl-Barzinji', 'Suhaib', null, 'Al-Barzinji', 'sbarzinji@cipe.org', null, null, '6946', '2009-05-01 00:00:00.000', '2004-11-08 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('65', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'LVanasek', 'Lynnea', null, 'Vanasek', 'lvanasek@cipe.org', null, null, '6961', '2005-04-01 00:00:00.000', '2004-11-23 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('66', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'TAbu-Hassan', 'Talal', null, 'Abu-Hassan', 'thassan@cipe.org', null, null, '6964', null, '2004-11-24 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('67', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'MKidder', 'Michael', null, 'Kidder', 'mkidder@cipe.org', null, null, '7042', '2005-04-18 00:00:00.000', '2005-02-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('68', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'ESpiro', 'Eugene', null, 'Spiro', 'espiro@cipe.org', null, null, '7036', null, '2005-01-10 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('69', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'JReutershan', 'Jennifer', null, 'Reutershan', 'jreutershan@cipe.org', null, null, '5653', null, '2005-02-16 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('72', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'BMillis', 'Brooke', null, 'Millis', 'bmillis@cipe.org', null, null, '7090', null, '2005-03-15 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('73', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'KEfinger', 'Kipp', null, 'Efinger', 'kefinger@cipe.org', null, null, '7192', null, '2005-05-06 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('74', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'KMcCoy', 'Kathryn', null, 'McCoy', 'kmccoy@cipe.org', null, null, '7132', '2006-08-31 00:00:00.000', '2005-04-13 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('77', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'SSiegel', 'Sarah', null, 'Siegel', 'ssiegel@cipe.org', null, null, '7189', null, '2005-05-06 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('81', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'DJohnson', 'Doreene', null, 'Johnson', 'djohnson@cipe.org', null, null, '7243', '2008-03-12 00:00:00.000', '2005-05-20 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('82', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'CCole', 'Chris', null, 'Cole', 'ccole@cipe.org', null, null, '7240', '2008-03-12 00:00:00.000', '2005-05-20 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('83', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'GWillhauck', 'Gregg', null, 'Willhauck', 'gwillhauck@cipe.org', null, null, '7219', null, '2005-05-20 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('84', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'IFakir', 'Intissar', null, 'Fakir', 'Ifakir@cipe.org', null, null, '7285', '2008-04-23 00:00:00.000', '2005-06-08 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('88', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'CWilliams', 'Cheryl', null, 'Williams', 'cwilliams@cipe.org', null, null, '7351', null, '2005-07-15 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('89', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'MJung', 'Mary Grace', null, 'Jung', 'mjung@cipe.org', null, null, '7342', null, '2005-07-15 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('90', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'SToze', 'Sariah', null, 'Toze', 'stoze@cipe.org', null, null, '7348', '2006-09-08 00:00:00.000', '2005-07-15 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('91', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'DSherk', 'Don', null, 'Sherk', 'dsherk@cipe.org', null, null, '7375', null, '2005-08-11 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('95', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'KBettcher', 'Kim', null, 'Bettcher', 'kbettcher@cipe.org', null, null, '7429', null, '2005-09-12 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('98', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'MFudda', 'Moin', null, 'Fudda', 'mfudda@cipe.org', null, null, '7432', null, '2005-09-15 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('101', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'EHallinan', 'Elizabeth', null, 'Hallinan', 'Ehallinan@cipe.org', null, null, '7567', null, '2006-01-17 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('102', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'TBisbee', 'Tim', null, 'Bisbee', 'tbisbee@cipe.org', null, null, '7666', '2007-03-29 00:00:00.000', '2006-03-13 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('103', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'DO''Maley', 'Dan', null, 'O''Maley', 'DOMaley@cipe.org', null, null, '7699', null, '2006-04-12 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('105', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'SSahani', 'Shirin', null, 'Sahani', 'SSahani@cipe.org', null, null, '7915', null, '2006-08-01 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('106', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'MKamuyu', 'Muthoni', null, 'Kamuyu', 'mkamuyu@cipe.org', null, null, '7921', '2008-01-04 00:00:00.000', '2006-08-01 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('107', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'JDoumato', 'Jennifer', null, 'Doumato', 'Jdoumato@cipe.org', null, null, '7918', null, '2006-08-01 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('108', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'MYoshida', 'Michiyuki', null, 'Yoshida', 'Myoshida@cipe.org', null, null, '8011', '2006-09-25 00:00:00.000', '2006-08-28 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('109', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'TWallace', 'Tim', null, 'Wallace', 'twallace@cipe.org', null, null, '8083', null, '2006-09-27 00:00:00.000', '0', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('110', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'CDeVito', 'Chris', null, 'DeVito', 'cdevito@cipe.org', null, null, '8110', null, '2006-10-11 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('111', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'AWorkman', 'Amanda', null, 'Workman', 'aworkman@cipe.org', null, null, '8098', '2008-01-10 00:00:00.000', '2006-10-11 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('112', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'MKortbawi', 'Mary', null, 'Kortbawi', 'mkortbawi@cipe.org', null, null, '8779', '2008-10-29 00:00:00.000', '2007-10-15 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('113', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'RBadaro', 'Roy', null, 'Badaro', 'rbadaro@cipe.org', null, null, '8122', '2008-09-24 00:00:00.000', '2006-10-28 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('114', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'JFernando', 'Johanna', null, 'Fernando', 'Jfernando@cipe.org', null, null, '8173', null, '2007-01-03 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('115', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'KBakleh', 'Kareina', null, 'Bakleh', 'khbakleh@cipe.org', null, null, '8236', null, '2007-02-14 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('116', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'NShell', 'Nickisha', null, 'Shell', 'nshell@cipe.org', null, null, '8254', null, '2007-02-28 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('117', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'AAlkebsi', 'Abdulwahab', null, 'Alkebsi', 'Alkebsi@cipe.org', null, null, '8287', null, '2007-03-12 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('118', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'LWafi', 'Linda', null, 'Wafi', 'lwafi@cipe.org', null, null, '8782', null, '2007-10-15 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('119', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'AAyadi', 'Ali', null, 'Ayadi', 'aayadi@cipe.org', null, null, '8791', null, '2007-10-22 00:00:00.000', '0', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('120', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'EHontz', 'Eric', null, 'Hontz', 'ehontz@cipe.org', null, null, '8314', null, '2007-03-28 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('121', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'DWaggoner', 'Daniel', null, 'Waggoner', 'dwaggoner@cipe.org', null, null, '8335', null, '2007-04-02 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('122', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'ANadgrodkiewicz', 'Anna', null, 'Nadgrodkiewicz', 'anadgrodkiewicz@cipe.org', null, null, '8377', null, '2007-05-01 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('123', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'BRuth', 'Brenton', null, 'Ruth', 'bruth@cipe.org', null, null, '8840', null, '2007-12-05 00:00:00.000', '0', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, '5');
GO
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('124', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'NOtel Belan', 'Natalia', null, 'Otel Belan', 'notelbelan@cipe.org', null, null, '8389', null, '2007-05-09 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('125', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'AIbrahim', 'Angela', null, 'Ibrahim', 'aibrahim@cipe.org', null, null, '8386', '2008-03-12 00:00:00.000', '2007-05-09 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('126', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'KCreel', 'Katherine', null, 'Creel', 'kcreel@cipe.org', null, null, '8416', null, '2007-05-14 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('127', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'CTetu-Atagwe', 'Claris', null, 'Tetu-Atagwe', 'catagwe@cipe.org', null, null, '9350', null, '2008-07-03 00:00:00.000', '0', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('128', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'TMishriki', 'Tahani', null, 'Mishriki', 'Tmishriki@cipe.org', null, null, '0000', null, '2008-09-17 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('129', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'DGreenfield', 'Danya', null, 'Greenfield', 'dgreenfield@cipe.org', null, null, '8707', null, '2007-09-12 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('130', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'MHaroun', 'Mahir', null, 'Haroun', 'mharoun@cipe.org', null, null, '8704', '2007-10-09 00:00:00.000', '2007-08-13 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('131', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'GSasse', 'Gail', null, 'Sasse', 'gsasse@cipe.org', null, null, '8722', '2008-11-14 00:00:00.000', '2007-09-12 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('133', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'CScullin', 'Caroline', null, 'Scullin', 'cscullin@cipe.org', null, null, '9050', null, '2008-03-26 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('134', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'BBruton', 'Bronwyn', null, 'Bruton', 'bbruton@cipe.org', null, null, '9047', null, '2008-03-12 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('135', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'JMancuso', 'Julie', null, 'Mancuso', 'jmancuso@cipe.org', null, null, '9056', null, '2008-03-26 00:00:00.000', '0', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('137', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'KBakleh', 'Khaled', null, 'Bakleh', 'kbakleh@cipe.org', null, null, '8719', '2009-05-01 00:00:00.000', '2007-08-26 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('138', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'TAl-Salaita', 'Tareq', null, 'Al-Salaita', 'Tsalaita@Cipe.org', null, null, '9140', null, '2008-05-07 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('139', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'JApikian', 'Jonathan', null, 'Apikian', 'JApikian@cipe.org', null, null, '9191', '2011-08-01 00:00:00.000', '2008-05-21 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('140', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'AEl-Sharkawy', 'Amina', null, 'El-Sharkawy', 'ASharkawy@cipe.org', null, null, '9332', null, '2008-07-02 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('141', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'KGreene', 'Kathryn', null, 'Greene', 'kgreene@cipe.org', null, null, '9347', null, '2008-07-02 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('142', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'OAbello', 'Oscar', null, 'Abello', 'oabello@cipe.org', null, null, '9356', null, '2008-07-02 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('143', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'MSchleifer', 'Marc', null, 'Schleifer', 'Mschleifer@cipe.org', null, null, '9344', null, '2008-07-02 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('144', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'TWilson', 'Tabitha', null, 'Wilson', 'Twilson@cipe.org', null, null, '9353', null, '2008-07-03 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('145', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'KBurgess', 'Kyle', null, 'Burgess', 'Kburgess@cipe.org', null, null, '9575', null, '2008-10-08 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('146', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'MPrincipe', 'Marie', null, 'Principe', 'Mprincipe@cipe.org', null, null, '9560', null, '2008-10-08 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('147', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'ATempAsia', 'Andrew', null, 'TempAsia', 'TempAsia@cipe.org', null, null, null, null, '2009-08-27 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('148', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'ACoale', 'Ashley', null, 'Coale', 'acoale@cipe.org', null, null, '9458', null, '2008-08-26 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('149', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'RFoster', 'Ryan', null, 'Foster', 'Rfoster@cipe.org', null, null, '9470', null, '2008-08-26 10:20:18.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('150', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'GSimpson', 'Gregory', null, 'Simpson', 'gsimpson@cipe.org', null, null, '9512', null, '2008-09-09 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('151', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'PTai', 'Pei Ju "Catherine"', null, 'Tai', 'Ctai@cipe.org', null, null, '9527', '2011-07-13 00:00:00.000', '2008-09-10 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('152', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'MNasib', 'Mohammed', null, 'Nasib', 'mnasib@cipe.org', null, null, '9572', null, '2008-10-22 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('153', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'KSpence', 'Kelly', null, 'Spence', 'Kspence@cipe.org', null, null, '9563', null, '2008-10-08 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('155', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'AAli', 'Abdelaziz', null, 'Ali', 'Aali@cipe.org', null, null, '9671', null, '2008-12-30 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('156', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'MO`Brien-Ali', 'Maura', null, 'O`Brien-Ali', 'Mobrienali@cipe.org', null, null, '9632', null, '2008-12-01 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('157', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'MSchultz', 'Mark', null, 'Schultz', 'Mschultz@cipe.org', null, null, '9629', null, '2008-12-02 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('158', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'ANicholson', 'Ali', null, 'Nicholson', 'anicholson@cipe.org', null, null, '9743', null, '2009-01-28 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('159', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'DMcCurdy', 'Daphne', null, 'McCurdy', 'DMcCurdy@cipe.org', null, null, '9710', null, '2008-12-31 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('160', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'NAmalu', 'Ngozika', null, 'Amalu', 'Namalu@cipe.org', null, null, '9731', null, '2009-01-14 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('161', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'MHendrix', 'Michael', null, 'Hendrix', 'Mhendrix@cipe.org', null, null, '9752', null, '2009-01-28 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('162', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'JMorrell', 'John', null, 'Morrell', 'Jmorrell@cipe.org', null, null, '9764', null, '2009-02-11 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('163', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'PLopez', 'Paul', null, 'Lopez', 'Plopez@cipe.org', null, null, '9968', null, '2009-12-02 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('164', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'PBriggs', 'Philip', null, 'Briggs', 'Pbriggs@cipe.org', null, null, '9806', null, '2009-02-25 00:00:00.000', '0', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('165', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'GBeirne', 'Greg', null, 'Beirne', 'Gbeirne@cipe.org', null, null, '9821', null, '2009-03-11 14:47:40.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('166', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'EHagel', 'Emily', null, 'Hagel', 'Ehagel@cipe.org', null, null, '6706', null, '2009-03-19 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('167', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'JScanlon', 'Joel', null, 'Scanlon', 'Jscanlon@cipe.org', null, null, '9839', null, '2009-04-08 13:00:38.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('168', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'MAngwafo', 'Manka', null, 'Angwafo', 'Mangwafo@cipe.org', null, null, '0097', null, '2010-04-14 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('169', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'JLiddell', 'James', null, 'Liddell', 'Jliddell@cipe.org', null, null, '9846', '2011-08-01 00:00:00.000', '2009-04-22 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('171', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'EPoff', 'Erica', null, 'Poff', 'EPoff@cipe.org', null, null, '9974', null, '2009-12-30 00:00:00.000', '0', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('173', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'JKindle', 'Julia', null, 'Kindle', 'Jely@cipe.org', null, null, '9942', null, '2009-10-07 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('174', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'LBenson', 'Lars', null, 'Benson', 'Lbenson@cipe.org', null, null, '9951', null, '2009-11-04 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('177', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'TNoel', 'Tamara', null, 'Noel', 'Tnoel@cipe.org', null, null, '9954', null, '2009-11-04 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('178', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'KDe Meo', 'Kristian', null, 'De Meo', 'Kdemeo@cipe.org', null, null, '9966', null, '2009-12-02 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('179', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'ALahlou', 'Aicha', null, 'Lahlou', 'Alahlou@cipe.org', null, null, '9973', null, '2009-12-30 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('181', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'AGutan', 'Ahmed', null, 'Gutan', 'Agutan@cipe.org', null, null, '9986', null, '2010-01-27 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('183', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'BYektafar', 'Babak', null, 'Yektafar', 'Byektafar@cipe.org', null, null, '1056', null, '2010-03-10 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('184', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'ABeitman', 'Aaron', null, 'Beitman', 'abeitman@cipe.org', null, null, '1060', null, '2010-03-24 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('186', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'ZIonova', 'Zoya', null, 'Ionova', 'Zionova@cipe.org', null, null, '1083', null, '2010-04-07 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('187', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'LCitrome', 'Lauren', null, 'Citrome', 'lcitrome@cipe.org', null, null, '1142', null, '2010-06-16 00:00:00.000', '0', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('188', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'SGerrity', 'Sarah', null, 'Gerrity', 'Sgerrity@cipe.org', null, null, '1178', null, '2010-07-28 00:00:00.000', '0', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('189', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'TFinance2', 'Temp', null, 'Finance2', 'tempfinance2@cipe.org', null, null, null, null, '2011-08-09 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('190', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'AHoward', 'Adam', null, 'Howard', 'AHoward@cipe.org', null, null, '1348', '2011-08-01 00:00:00.000', '2011-05-18 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('191', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'DSmith', 'Dorothy', null, 'Smith', 'Dsmith@cipe.org', null, null, '1203', null, '2010-09-22 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('192', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'SElmahdi', 'Shaza', null, 'Elmahdi', 'Selmahdi@cipe.org', null, null, '1204', null, '2010-09-22 00:00:00.000', '0', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('193', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'FBrown', 'Frank', null, 'Brown', 'Fbrown@cipe.org', null, null, '1220', null, '2010-10-06 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('194', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'JGodoy', 'Jorge', null, 'Godoy', 'Jgodoy@cipe.org', null, null, '1227', null, '2010-10-20 00:00:00.000', '1', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('195', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'AWeber', 'Anna', null, 'Weber', 'Aweber@cipe.org', null, null, '1226', null, '2010-10-20 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('196', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'PHouston', 'Paulette', null, 'Houston', 'Phouston@cipe.org', null, null, '1309', null, '2011-03-20 00:00:00.000', '0', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('197', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'SBuck', 'Stephanie', null, 'Buck', 'Sbuck@cipe.org', null, null, '1239', null, '2010-11-03 00:00:00.000', '0', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('198', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'AThornberry', 'Amy', null, 'Thornberry', 'Athornberry@cipe.org', null, null, '1238', null, '2010-11-03 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('199', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'JSwirszcz', 'Joanna', null, 'Swirszcz', 'Jswirszcz@cipe.org', null, null, '1241', null, '2010-11-03 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('200', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'PBeecroft', 'Pamela', null, 'Beecroft', 'Pbeecroft@cipe.org', null, null, '1243', null, '2010-11-17 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('201', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'KSutara', 'Kristen', null, 'Sutara', 'ksutara@cipe.org', null, null, '1390', null, '2011-07-12 00:00:00.000', '0', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, '2');
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('202', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'VShalaginova', 'Viktoria', null, 'Shalaginova', 'vshalaginova@cipe.org', null, null, '1425', null, '2011-08-24 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('203', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'DAbi-Rached', 'Dina', null, 'Abi-Rached', 'Dabirached@cipe.org', null, null, '1291', null, '2011-03-02 00:00:00.000', '0', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('205', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'MNakagaki', 'Maiko', null, 'Nakagaki', 'mnakagaki@cipe.org', null, null, '1387', null, '2011-07-12 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('206', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'MMiller', 'Man-Hsiu', null, 'Miller', 'MChen@cipe.org', null, null, '1389', null, '2011-07-13 00:00:00.000', '0', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('207', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'JZanikos', 'John', null, 'Zanikos', 'jzanikos@cipe.org', null, null, '1388', null, '2011-07-13 00:00:00.000', '0', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('208', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'PPicz', 'Piotr', null, 'Picz', 'PPicz@cipe.org', null, null, '1403', null, '2011-07-27 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('210', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'NGrubman', 'Nate', null, 'Grubman', 'ngrubman@cipe.org', null, null, '1394', null, '2011-07-27 00:00:00.000', '0', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('212', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'TTempEurasia', 'Temp', null, 'TempEurasia', null, null, null, '0700', null, '2012-09-15 00:00:00.000', '1', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('214', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'RWilliams', 'Rita', null, 'Williams', 'rwilliams@cipe.org', null, null, '1449', null, '2011-10-05 00:00:00.000', '0', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('215', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'YHongla', 'Yana', null, 'Hongla', 'Yhongla@cipe.org', null, null, '1457', null, '2011-11-02 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('216', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'JCuster', 'Jonathan', null, 'Custer', 'Jcuster@cipe.org', null, null, '1458', null, '2011-11-02 00:00:00.000', '0', '40.000', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('217', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'MBrister', 'Molly', null, 'Brister', 'mbrister@cipe.org', null, null, '5500', null, '2011-11-16 00:00:00.000', '0', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('218', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'RGrossman', 'Rachel', null, 'Grossman', 'rgrossman@cipe.org', null, null, '1472', null, '2011-11-16 00:00:00.000', '0', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('219', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'LTourtellotte', 'Laura', null, 'Tourtellotte', 'Ltourtellotte@cipe.org', null, null, '1480', null, '2011-11-30 00:00:00.000', '0', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('220', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'DMack', 'David', null, 'Mack', 'dmack@cipe.org', null, null, '1490', null, '2011-12-28 00:00:00.000', '0', '37.500', '2012-01-19 11:34:57.000', '211', '2012-01-19 11:34:57.000', '211', null, null, null, null, null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('221', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'JDoe', 'John', '', 'Doe', null, '', 'Active', '', null, null, null, null, null, '211', '2012-01-31 01:43:56.477', '211', null, null, null, '2012-01-31 01:43:56.477', null);
INSERT INTO [userinfo] ([id], [password], [loginname], [firstname], [middlename], [lastname], [email], [phone], [statuscode], [employeeid], [enddate], [startdate], [inactive], [requiredhours], [creationdate], [createdby], [lastupdated], [lastupdatedby], [fieldofficeid], [regionid], [usertypeid], [createdate], [preferenceid]) VALUES ('224', '2A97516C354B68848CDBD8F54A226A0A55B21ED138E207AD6C5CBB9C00AA5AEA', 'fstroker', 'Frank', '', 'Stroker', null, '', 'Active', '', null, null, null, null, null, '211', '2012-03-14 13:21:15.490', '211', null, null, null, '2012-03-14 13:21:15.490', null);
GO
SET IDENTITY_INSERT [userinfo] OFF
GO

-- ----------------------------
-- Records of usertype
-- ----------------------------
SET IDENTITY_INSERT [usertype] ON
GO
SET IDENTITY_INSERT [usertype] OFF
GO


-- ----------------------------
-- Records of actionablealerts
-- ----------------------------
INSERT INTO [actionablealerts] ([id], [module], [type], [createdby], [createdate], [lastupdated], [lastupdatedby], [description]) VALUES ('1', 'Partner Monitoring', 'AASS Overdue', null, null, null, null, 'When the Final Audit Selection Memo Due Date is past and no final Selection Memo has been received.');
INSERT INTO [actionablealerts] ([id], [module], [type], [createdby], [createdate], [lastupdated], [lastupdatedby], [description]) VALUES ('2', 'Partner Monitoring', 'Final Audit Past Due', null, null, null, null, 'When the Final Audit Due Date is past Due and no Final Audit has been received.');
INSERT INTO [actionablealerts] ([id], [module], [type], [createdby], [createdate], [lastupdated], [lastupdatedby], [description]) VALUES ('3', 'Partner Grant', 'Financial Report Past Due', null, null, null, null, 'When the Financial Report Due Date is past Due and the Report has not yet been received .');
INSERT INTO [actionablealerts] ([id], [module], [type], [createdby], [createdate], [lastupdated], [lastupdatedby], [description]) VALUES ('4', 'Partner Monitoring', 'Interim Audit Past Due', null, null, null, null, 'When the Interim Audit Due Date is past Due and no Interim Audit has been received.');
INSERT INTO [actionablealerts] ([id], [module], [type], [createdby], [createdate], [lastupdated], [lastupdatedby], [description]) VALUES ('5', 'Partner Grant', 'Narrative Report Past Due', null, null, null, null, 'When the Narrative Report Due Date is past Due and the Report has not yet been received.');
INSERT INTO [actionablealerts] ([id], [module], [type], [createdby], [createdate], [lastupdated], [lastupdatedby], [description]) VALUES ('6', 'Partner Monitoring', 'Past Due IMP', null, null, null, null, 'When the IMP Due Date is Past Due and no IMP has been Performed.');
INSERT INTO [actionablealerts] ([id], [module], [type], [createdby], [createdate], [lastupdated], [lastupdatedby], [description]) VALUES ('7', 'Payment Request', 'Overdue Payment Request', null, null, null, null, 'When a Payment Request has been Open for 30 days without the status being changed to "Paid" or "Cancelled".');
INSERT INTO [actionablealerts] ([id], [module], [type], [createdby], [createdate], [lastupdated], [lastupdatedby], [description]) VALUES ('8', 'Payment Request', 'Rejected Payment Request', null, null, null, null, 'When the status of a Payment Request has been set to "Rejected".');
INSERT INTO [actionablealerts] ([id], [module], [type], [createdby], [createdate], [lastupdated], [lastupdatedby], [description]) VALUES ('9', 'Partner Grant', 'No Partner Grant Payment Request Activity', null, null, null, null, 'When an "Active" Partner Grant type project started 60 days ago and there are no related payment requests associated with this Grant.');
INSERT INTO [actionablealerts] ([id], [module], [type], [createdby], [createdate], [lastupdated], [lastupdatedby], [description]) VALUES ('10', 'Project Summary', 'No Project Payment Request Activity', null, null, null, null, 'When an "Active" Project started 60 days ago and there has been no payment Request activity for the project.');
INSERT INTO [actionablealerts] ([id], [module], [type], [createdby], [createdate], [lastupdated], [lastupdatedby], [description]) VALUES ('11', 'Partner Grant', 'Partner Grant Signature Not Received', null, null, null, null, 'When the "Start Date" of a Partner Grant type project has been reached but the Sign Agreement has not been received from the Partner.');
INSERT INTO [actionablealerts] ([id], [module], [type], [createdby], [createdate], [lastupdated], [lastupdatedby], [description]) VALUES ('12', 'Donor Awards View', 'Donor Award Ending', null, null, null, null, 'When the Donor Award End Date is within 90 days.');
GO

-- ----------------------------
-- Records of alerttype
-- ----------------------------
SET IDENTITY_INSERT [alerttype] ON
GO
INSERT INTO [alerttype] ([id], [typename], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('2', 'AASS Overdue', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211');
INSERT INTO [alerttype] ([id], [typename], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('3', 'Final Audit Past Due', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211');
INSERT INTO [alerttype] ([id], [typename], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('4', 'Financial Report Past Due', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211');
INSERT INTO [alerttype] ([id], [typename], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('5', 'Interim Audit Past Due', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211');
INSERT INTO [alerttype] ([id], [typename], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('6', 'Narrative Report Past Due', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211');
INSERT INTO [alerttype] ([id], [typename], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('7', 'Past Due IMP', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211');
INSERT INTO [alerttype] ([id], [typename], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('8', 'Overdue Payment Request', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211');
INSERT INTO [alerttype] ([id], [typename], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('9', 'Rejected Payment Request', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211');
INSERT INTO [alerttype] ([id], [typename], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('10', 'No Partner Grant Payment Request Activity', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211');
INSERT INTO [alerttype] ([id], [typename], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('11', 'No Project Payment Request Activity', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211');
INSERT INTO [alerttype] ([id], [typename], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('12', 'Partner Grant Signature Not Received', '2011-12-29 00:00:00.000', '1', '2011-12-29 00:00:00.000', '211');
GO
SET IDENTITY_INSERT [alerttype] OFF
GO


-- ----------------------------
-- Records of link
-- ----------------------------
SET IDENTITY_INSERT [link] ON
GO
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('1', '1', 'Add Donor', 'showAddDonor.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('3', '3', 'Donor List', 'showDonorList.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('26', '2', 'Edit Donor', 'searchDonor.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('27', '4', 'Add Donor Award', 'showAddDonoraward.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('28', '5', 'View - Donor Award', 'findDonoraward.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('29', '3', 'View Donor Awards', 'showDonorawardList.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('30', '1', 'Add Project', 'showAddCipeproject.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('31', '4', 'View - Projects and Grants', 'findCipeproject.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('32', '3', 'View Projects / Grants', 'showCipeprojectList.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('33', '1', 'Add Partner', 'showAddPartnergrant.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('34', '2', 'Edit Partner', 'searchPartner.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('35', '3', 'View Partner', 'showPartnerList.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('36', '1', 'Enter Financial and Narrative Reporting Requirements', 'showAddFinNarRepReq.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('37', '2', 'Edit Financial and Narrative Reporting Requirements', 'showEditFinNarRepReq.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('38', '1', 'Enter Audit Details', 'showAddAudit.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('39', '2', 'Edit Audit Details', 'searchAudit.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('40', '3', 'View Audits', 'showAuditList.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('41', '1', 'Add Payment Request', 'showAddPaymentrequest.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('42', '2', 'View - Payment Request', 'findPaymentrequest.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('43', '3', 'View Payment Requests', 'showPaymentrequestList.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('44', '4', 'Process Payment Request', 'processPaymentReq.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('45', '5', 'Instructions', 'showInstructionsPaymentReq.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('46', '1', 'Add Payee', 'showAddPayee.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('47', '2', 'Edit Payee', 'searchPayee.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('48', '3', 'View Payee''s', 'showPayeeList.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('49', '1', 'Reports List', 'showReportList.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('50', '1', 'Email Grants Management', 'showEmailGrantManagement.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('51', '2', 'Report Computer Problem to Help Desk', 'reportComputerProblem.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('52', '3', 'CMRS System Requests - Add User, etc.', 'systemReq.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('53', '3', 'Manage Roles', 'showAddRole.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('54', '4', 'View Roles', 'showRoleList.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('55', '31', 'Manage KM Organization Types', 'showAddOrganizationtype.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('57', '1', 'Manage Users', 'showAddUser.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('58', '2', 'View Users', 'showUserList.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('59', '3', 'Enter Partner Monitoring Details', 'showAddPartnerMonDetail.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('60', '4', 'Edit Partner Monitoring Details', 'showEditPartnerMonDetail.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('61', '5', 'View Partner Monitoring Details', 'showPartnerMonDetail.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('62', '29', 'Manage Account Codes', 'showAddAccountCode.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('63', '5', 'Manage Regions', 'showAddRegion.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('64', '15', 'Manage Donor Award Statuses', 'showAddDonorawardstatus.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('65', '13', 'Manage Donor Award Types', 'showAddDonorawardtype.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('66', '19', 'Manage Project Statuses', 'showAddCipeprojectstatus.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('67', '17', 'Manage Project Types', 'showAddCipeprojecttype.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('68', '23', 'Manage Partner Grant Statuses', 'showPageHeading.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('69', '21', 'Manage Partner Grant Types', 'showPageHeading.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('70', '27', 'Manage Payment Request Statuses', 'showAddPaymentrequeststatus.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('71', '25', 'Manage Payment Request Types', 'showAddPaymentrequesttype.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('72', '1', 'Control Panel (CMRS Home)', 'showPageHeading.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('73', '6', 'View Regions', 'showRegionList.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('74', '7', 'Manage Countries', 'showAddCountry.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('75', '8', 'View Countries', 'showCountryList.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('76', '9', 'Manage States', 'showAddState.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('77', '10', 'View States', 'showStateList.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('78', '11', 'Manage Field Offices', 'showAddFieldoffice.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('79', '12', 'View Field Offices', 'showFieldofficeList.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('80', '14', 'View Donor Award Types', 'showDonorawardtypeList.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('81', '16', 'View Donor Award Statuses', 'showDonorawardstatusList.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('82', '18', 'View Project Types', 'showCipeprojecttypeList.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('83', '20', 'View Project Statuses', 'showCipeprojectstatusList.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('84', '26', 'View Payment Request Types', 'showPaymentrequesttypeList.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('85', '28', 'View Payment Request Statuses', 'showPaymentrequeststatusList.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('86', '22', 'View Partner Grant Types', 'showPageHeading.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('87', '24', 'View Partner Grant Statuses', 'showPageHeading.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('88', '30', 'View Account Codes', 'showAccountCodeList.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('89', '32', 'View KM Organization Types', 'showOrganizationtypeList.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('90', '33', 'Manage KM Organization Keywords', 'showAddKeyword.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('91', '34', 'View KM Organization Keywords', 'showKeywordList.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('92', '2', 'Add Partner Grant', 'showAddPartnergrant.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('93', '5', 'View - Partner Grant', 'findPartnergrant.do', null, null, null, null);
INSERT INTO [link] ([id], [displayorder], [displayname], [url], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('94', '1', 'Project Catalogue', 'findKnowledgeManagement.do', null, null, null, null);
GO
SET IDENTITY_INSERT [link] OFF
GO

-- ----------------------------
-- Records of linkcategory
-- ----------------------------
SET IDENTITY_INSERT [linkcategory] ON
GO
INSERT INTO [linkcategory] ([id], [displayorder], [displayname], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('1', '1', 'Donors and Donor Awards', null, null, null, null);
INSERT INTO [linkcategory] ([id], [displayorder], [displayname], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('2', '3', 'Projects and Grants', null, null, null, null);
INSERT INTO [linkcategory] ([id], [displayorder], [displayname], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('3', '7', 'Payment Processing', null, null, null, null);
INSERT INTO [linkcategory] ([id], [displayorder], [displayname], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('4', '11', 'System Administration', null, null, null, null);
INSERT INTO [linkcategory] ([id], [displayorder], [displayname], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('5', '9', 'Reports', null, null, null, null);
INSERT INTO [linkcategory] ([id], [displayorder], [displayname], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('11', '8', 'Project Catalogue', null, null, null, null);
INSERT INTO [linkcategory] ([id], [displayorder], [displayname], [createdate], [createdby], [lastupdated], [lastupdateby]) VALUES ('12', '10', 'Contact Us', null, null, null, null);
GO
SET IDENTITY_INSERT [linkcategory] OFF
GO

-- ----------------------------
-- Records of categorylinks
-- ----------------------------
SET IDENTITY_INSERT [categorylinks] ON
GO
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('1', '1', '1');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('2', '3', '1');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('3', '30', '2');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('4', '88', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('5', '89', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('6', '90', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('7', '91', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('8', '92', '2');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('9', '93', '2');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('10', '79', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('11', '53', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('12', '54', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('13', '31', '2');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('14', '41', '3');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('15', '42', '3');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('16', '45', '3');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('17', '55', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('18', '73', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('19', '49', '5');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('20', '27', '1');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('21', '28', '1');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('22', '74', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('23', '94', '11');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('24', '50', '12');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('25', '51', '12');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('26', '52', '12');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('27', '57', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('28', '58', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('29', '62', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('30', '63', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('31', '64', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('32', '65', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('33', '66', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('34', '67', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('35', '70', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('36', '71', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('37', '75', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('38', '76', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('39', '77', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('40', '78', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('41', '80', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('42', '81', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('43', '82', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('44', '83', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('45', '84', '4');
INSERT INTO [categorylinks] ([id], [linkid], [linkcategoryid]) VALUES ('46', '85', '4');
GO
SET IDENTITY_INSERT [categorylinks] OFF
GO

-- ----------------------------
-- Records of changenotificationtype
-- ----------------------------
SET IDENTITY_INSERT [changenotificationtype] ON
GO
INSERT INTO [changenotificationtype] ([id], [typename], [createdate], [createdby], [lastupdated], [lastupdatedby], [module], [type], [description]) VALUES ('2', 'Payment Request Status Change', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211', 'Payment Request ', null, 'When the Status of a Payment Request changes.');
INSERT INTO [changenotificationtype] ([id], [typename], [createdate], [createdby], [lastupdated], [lastupdatedby], [module], [type], [description]) VALUES ('3', 'Project Management Funds Changed', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211', 'Projects Summary', null, 'When the Management Funds amount changes.');
INSERT INTO [changenotificationtype] ([id], [typename], [createdate], [createdby], [lastupdated], [lastupdatedby], [module], [type], [description]) VALUES ('4', 'Partner Grants Funds Changed', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211', 'Partner Grant Summary', null, 'When the Partner Grant Funds amount changes.');
INSERT INTO [changenotificationtype] ([id], [typename], [createdate], [createdby], [lastupdated], [lastupdatedby], [module], [type], [description]) VALUES ('5', 'Project Start Date Changed', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211', 'Projects Summary', null, 'When the Start Date of a project changes.');
INSERT INTO [changenotificationtype] ([id], [typename], [createdate], [createdby], [lastupdated], [lastupdatedby], [module], [type], [description]) VALUES ('6', 'Project End Date Changed', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211', 'Projects Summary', null, 'When the End Date of a project changes.');
INSERT INTO [changenotificationtype] ([id], [typename], [createdate], [createdby], [lastupdated], [lastupdatedby], [module], [type], [description]) VALUES ('7', 'Grant Start Date Changed', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211', 'Partner Grant Summary', null, 'When the  Grant Start Date of a project changes.');
INSERT INTO [changenotificationtype] ([id], [typename], [createdate], [createdby], [lastupdated], [lastupdatedby], [module], [type], [description]) VALUES ('8', 'Grant End Date Changed', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211', 'Partner Grant Summary', null, 'When the Grant End Date of a project changes.');
INSERT INTO [changenotificationtype] ([id], [typename], [createdate], [createdby], [lastupdated], [lastupdatedby], [module], [type], [description]) VALUES ('9', 'Project Status Change', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211', 'Projects  Summary', null, 'When the Status of a project changes.');
INSERT INTO [changenotificationtype] ([id], [typename], [createdate], [createdby], [lastupdated], [lastupdatedby], [module], [type], [description]) VALUES ('10', 'Grant Status Change', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211', 'Partner Grant Summary', null, 'When the Status of a Grant changes.');
GO
SET IDENTITY_INSERT [changenotificationtype] OFF
GO

-- ----------------------------
-- Records of donorawardstatus
-- ----------------------------
SET IDENTITY_INSERT [donorawardstatus] ON
GO
INSERT INTO [donorawardstatus] ([id], [statusname], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('1', 'New', '211', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000');
INSERT INTO [donorawardstatus] ([id], [statusname], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('2', 'Over', '211', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000');
INSERT INTO [donorawardstatus] ([id], [statusname], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('3', 'Closed', '211', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000');
INSERT INTO [donorawardstatus] ([id], [statusname], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('4', 'Cancelled', '211', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000');
INSERT INTO [donorawardstatus] ([id], [statusname], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('5', 'Active', '211', '2012-01-31 00:00:00.000', '211', '2012-01-31 00:00:00.000');
INSERT INTO [donorawardstatus] ([id], [statusname], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('6', 'Pending', '211', '2012-01-31 00:00:00.000', '211', '2012-01-31 00:00:00.000');
GO
SET IDENTITY_INSERT [donorawardstatus] OFF
GO

-- ----------------------------
-- Records of donorawardtype
-- ----------------------------
SET IDENTITY_INSERT [donorawardtype] ON
GO
INSERT INTO [donorawardtype] ([id], [donorawardtypedesc], [donorawardtype], [createdby], [createdate], [lastupdated], [lastupdatedby], [deleted]) VALUES ('1', 'Used for Internal Accounting', 'Internal', '211', '2011-12-29 00:00:00.000', '2011-12-29 00:00:00.000', '211', null);
INSERT INTO [donorawardtype] ([id], [donorawardtypedesc], [donorawardtype], [createdby], [createdate], [lastupdated], [lastupdatedby], [deleted]) VALUES ('2', 'NED Funds to CIPE as a core NED Institute', 'NED Core', '211', '2011-12-29 00:00:00.000', '2011-12-29 00:00:00.000', '211', null);
INSERT INTO [donorawardtype] ([id], [donorawardtypedesc], [donorawardtype], [createdby], [createdate], [lastupdated], [lastupdatedby], [deleted]) VALUES ('3', 'NED Special Funds not associated with Core Grant', 'NED Special Funds', '211', '2011-12-29 00:00:00.000', '2011-12-29 00:00:00.000', '211', null);
INSERT INTO [donorawardtype] ([id], [donorawardtypedesc], [donorawardtype], [createdby], [createdate], [lastupdated], [lastupdatedby], [deleted]) VALUES ('4', 'Private funds and other sources', 'Other', '211', '2011-12-29 00:00:00.000', '2011-12-29 00:00:00.000', '211', null);
INSERT INTO [donorawardtype] ([id], [donorawardtypedesc], [donorawardtype], [createdby], [createdate], [lastupdated], [lastupdatedby], [deleted]) VALUES ('5', 'Funds given without requiring milestones reached.', 'USAID Cooperative Agreement', '211', '2011-12-29 00:00:00.000', '2011-12-29 00:00:00.000', '211', null);
INSERT INTO [donorawardtype] ([id], [donorawardtypedesc], [donorawardtype], [createdby], [createdate], [lastupdated], [lastupdatedby], [deleted]) VALUES ('6', 'CIPE is the Primary Contractor on Direct Award', 'USAID Prime', '211', '2011-12-29 00:00:00.000', '2011-12-29 00:00:00.000', '211', null);
INSERT INTO [donorawardtype] ([id], [donorawardtypedesc], [donorawardtype], [createdby], [createdate], [lastupdated], [lastupdatedby], [deleted]) VALUES ('7', 'Funds given for specific milestones to be completed to qualify for payments', 'USAID Subcontract', '211', '2011-12-29 00:00:00.000', '2011-12-29 00:00:00.000', '211', null);
INSERT INTO [donorawardtype] ([id], [donorawardtypedesc], [donorawardtype], [createdby], [createdate], [lastupdated], [lastupdatedby], [deleted]) VALUES ('8', 'Used for USAID agreements using a Letter of Credit', 'USAID/State Department/L.O.C.', '211', '2011-12-29 00:00:00.000', '2011-12-29 00:00:00.000', '211', null);
GO
SET IDENTITY_INSERT [donorawardtype] OFF
GO

-- ----------------------------
-- Records of fieldoffice
-- ----------------------------
SET IDENTITY_INSERT [fieldoffice] ON
GO
INSERT INTO [fieldoffice] ([id], [fieldofficecode], [fieldofficename], [address1], [address2], [city], [contactemail], [contactname], [contactphone], [contactfax], [emailaddress], [phone], [fax], [stateprovince], [inactive], [createdate], [createdby], [lastupdated], [lastupdatedby], [countryid], [regionid]) VALUES ('1', 'Afghanistan', 'Afghanistan', null, null, null, null, null, null, null, null, null, null, null, null, '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211', null, null);
INSERT INTO [fieldoffice] ([id], [fieldofficecode], [fieldofficename], [address1], [address2], [city], [contactemail], [contactname], [contactphone], [contactfax], [emailaddress], [phone], [fax], [stateprovince], [inactive], [createdate], [createdby], [lastupdated], [lastupdatedby], [countryid], [regionid]) VALUES ('2', 'Egypt', 'Egypt', null, null, null, null, null, null, null, null, null, null, null, null, '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211', null, null);
INSERT INTO [fieldoffice] ([id], [fieldofficecode], [fieldofficename], [address1], [address2], [city], [contactemail], [contactname], [contactphone], [contactfax], [emailaddress], [phone], [fax], [stateprovince], [inactive], [createdate], [createdby], [lastupdated], [lastupdatedby], [countryid], [regionid]) VALUES ('3', 'Iraq', 'Iraq', null, null, null, null, null, null, null, null, null, null, null, null, '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211', null, null);
INSERT INTO [fieldoffice] ([id], [fieldofficecode], [fieldofficename], [address1], [address2], [city], [contactemail], [contactname], [contactphone], [contactfax], [emailaddress], [phone], [fax], [stateprovince], [inactive], [createdate], [createdby], [lastupdated], [lastupdatedby], [countryid], [regionid]) VALUES ('4', 'Pakistan', 'Pakistan', null, null, null, null, null, null, null, null, null, null, null, null, '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211', null, null);
INSERT INTO [fieldoffice] ([id], [fieldofficecode], [fieldofficename], [address1], [address2], [city], [contactemail], [contactname], [contactphone], [contactfax], [emailaddress], [phone], [fax], [stateprovince], [inactive], [createdate], [createdby], [lastupdated], [lastupdatedby], [countryid], [regionid]) VALUES ('5', 'Romania', 'Romania', null, null, null, null, null, null, null, null, null, null, null, null, '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211', null, null);
INSERT INTO [fieldoffice] ([id], [fieldofficecode], [fieldofficename], [address1], [address2], [city], [contactemail], [contactname], [contactphone], [contactfax], [emailaddress], [phone], [fax], [stateprovince], [inactive], [createdate], [createdby], [lastupdated], [lastupdatedby], [countryid], [regionid]) VALUES ('6', 'Russia', 'Russia', null, null, null, null, null, null, null, null, null, null, null, null, '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211', null, null);
INSERT INTO [fieldoffice] ([id], [fieldofficecode], [fieldofficename], [address1], [address2], [city], [contactemail], [contactname], [contactphone], [contactfax], [emailaddress], [phone], [fax], [stateprovince], [inactive], [createdate], [createdby], [lastupdated], [lastupdatedby], [countryid], [regionid]) VALUES ('7', 'Ukraine', 'Ukraine', null, null, null, null, null, null, null, null, null, null, null, null, '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211', null, null);
INSERT INTO [fieldoffice] ([id], [fieldofficecode], [fieldofficename], [address1], [address2], [city], [contactemail], [contactname], [contactphone], [contactfax], [emailaddress], [phone], [fax], [stateprovince], [inactive], [createdate], [createdby], [lastupdated], [lastupdatedby], [countryid], [regionid]) VALUES ('8', 'CIPE HQ', 'CIPE HQ', null, null, null, null, null, null, null, null, null, null, null, null, '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211', null, null);
GO
SET IDENTITY_INSERT [fieldoffice] OFF
GO

-- ----------------------------
-- Records of keyword
-- ----------------------------
SET IDENTITY_INSERT [keyword] ON
GO
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('1', 'access to credit', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('2', 'accounting', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('3', 'administrative code', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('4', 'administrative reform', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('5', 'advisory board', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('6', 'association governance', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('7', 'association social responsibil', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('8', 'association training', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('9', 'awareness raising', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('10', 'banks', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('11', 'blog', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('12', 'book', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('13', 'business associations', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('14', 'business education', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('15', 'business ethics', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('16', 'business plans', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('17', 'business registration', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('18', 'capacity building', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('19', 'case studies', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('20', 'certification', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('21', 'chambers of commerce', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('22', 'citizenship', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('23', 'civic education', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('24', 'civil society', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('25', 'coalition building', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('26', 'codes of conduct', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('27', 'commercial law', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('28', 'communications', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('29', 'communities of practice', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('30', 'competition policy', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('31', 'conference', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('32', 'constitution', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('33', 'consumer protection', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('34', 'corporate citizenship', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('35', 'corporate governance guideline', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('36', 'cost-benefit analysis', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('37', 'curriculum', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('38', 'customs regulations', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('39', 'database', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('40', 'decentralization', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('41', 'democratic values', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('42', 'directors training', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('43', 'directory', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('44', 'economic platforms', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('45', 'economics training', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('46', 'education', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('47', 'electronic commerce', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('48', 'energy policy', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('49', 'entrepreneurship', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('50', 'entrepreneurship training', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('51', 'essay contest', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('52', 'farmers', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('53', 'federalism', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('54', 'financial management', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('55', 'financial reform', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('56', 'fiscal reform', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('57', 'foreign investment', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('58', 'forum', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('59', 'freedom of information', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('60', 'handbook', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('61', 'health care', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('62', 'immigrant workers', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('63', 'index', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('64', 'indigenous populations', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('65', 'institute of directors', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('66', 'institutional investors', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('67', 'integrity pacts', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('68', 'intellectual property rights', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('69', 'internet', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('70', 'Islam and market reform', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('71', 'journal', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('72', 'journalism', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('73', 'journalist training', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('74', 'judiciary', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('75', 'knowledge sharing', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('76', 'labor law', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('77', 'leadership', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('78', 'legislative advisory', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('79', 'legislative monitoring', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('80', 'legislator training', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('81', 'legislators', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('82', 'licensing', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('83', 'local advocacy', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('84', 'local business agenda', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('85', 'local governance', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('86', 'magazine', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('87', 'management training', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('88', 'media', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('89', 'membership development', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('90', 'micro and small enterprises', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('91', 'national budget', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('92', 'national business agenda', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('93', 'networks', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('94', 'newspapers', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('95', 'pension reform', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('96', 'policy papers', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('97', 'policy roundtables', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('98', 'political debates', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('99', 'political parties', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('100', 'polls', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
GO
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('101', 'post-conflict', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('102', 'privatization', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('103', 'public private dialogue', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('104', 'public procurement', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('105', 'radio', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('106', 'rule of law', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('107', 'rural', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('108', 'scorecards', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('109', 'shareholders rights', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('110', 'small and medium enterprises', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('111', 'social security', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('112', 'state-owned enterprises', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('113', 'strategic planning', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('114', 'students', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('115', 'surveys', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('116', 'symposia', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('117', 'taxes', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('118', 'television', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('119', 'think tanks', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('120', 'toolkit', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('121', 'trade', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('122', 'training', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('123', 'training of trainers', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('124', 'transparency', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('125', 'unions', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('126', 'universities', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('127', 'websites', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('128', 'women', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
INSERT INTO [keyword] ([id], [keywordcode], [keyworddesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('129', 'youth', null, '211', '2011-12-29 13:35:32.000', '211', '2011-12-29 13:35:32.000');
GO
SET IDENTITY_INSERT [keyword] OFF
GO

-- ----------------------------
-- Records of modificationtype
-- ----------------------------
SET IDENTITY_INSERT [modificationtype] ON
GO
INSERT INTO [modificationtype] ([id], [modificationtypecode], [modificationdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('1', 'MTYPE_CODE1', 'Start Date Changed', null, null, null, null);
INSERT INTO [modificationtype] ([id], [modificationtypecode], [modificationdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('2', 'MTYPE_CODE2', 'End Date Changed', null, null, null, null);
INSERT INTO [modificationtype] ([id], [modificationtypecode], [modificationdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('3', 'MTYPE_CODE3', 'Direct Funds Reduced', null, null, null, null);
INSERT INTO [modificationtype] ([id], [modificationtypecode], [modificationdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('4', 'MTYPE_CODE4', 'Direct Funds Increased', null, null, null, null);
INSERT INTO [modificationtype] ([id], [modificationtypecode], [modificationdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('5', 'MTYPE_CODE5', 'Indirect Funds Reduced', null, null, null, null);
INSERT INTO [modificationtype] ([id], [modificationtypecode], [modificationdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('6', 'MTYPE_CODE6', 'Indirect Funds Increased', null, null, null, null);
INSERT INTO [modificationtype] ([id], [modificationtypecode], [modificationdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('7', 'MTYPE_CODE7', 'Status Changed', null, null, null, null);
INSERT INTO [modificationtype] ([id], [modificationtypecode], [modificationdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('8', 'MTYPE_CODE8', 'Management Funds Increased', null, null, null, null);
INSERT INTO [modificationtype] ([id], [modificationtypecode], [modificationdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('9', 'MTYPE_CODE9', 'Management Funds Reduced', null, null, null, null);
INSERT INTO [modificationtype] ([id], [modificationtypecode], [modificationdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('12', 'MTYPE_CODE10', 'Partner Grant Funds Increased', null, null, null, null);
INSERT INTO [modificationtype] ([id], [modificationtypecode], [modificationdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('13', 'MTYPE_CODE11', 'Partner Grant Funds Reduced', null, null, null, null);
GO
SET IDENTITY_INSERT [modificationtype] OFF
GO

-- ----------------------------
-- Records of organizationtype
-- ----------------------------
SET IDENTITY_INSERT [organizationtype] ON
GO
INSERT INTO [organizationtype] ([id], [organizationtypename], [organizationtypedesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('1', 'Business Association', null, '211', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000');
INSERT INTO [organizationtype] ([id], [organizationtypename], [organizationtypedesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('2', 'Business Association/NGO', null, '211', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000');
INSERT INTO [organizationtype] ([id], [organizationtypename], [organizationtypedesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('3', 'Business Association/Think Tank', null, '211', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000');
INSERT INTO [organizationtype] ([id], [organizationtypename], [organizationtypedesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('4', 'Educational Institution', null, '211', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000');
INSERT INTO [organizationtype] ([id], [organizationtypename], [organizationtypedesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('5', 'In-house', null, '211', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000');
INSERT INTO [organizationtype] ([id], [organizationtypename], [organizationtypedesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('6', 'NGO', null, '211', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000');
INSERT INTO [organizationtype] ([id], [organizationtypename], [organizationtypedesc], [createdby], [createdate], [lastupdatedby], [lastupdated]) VALUES ('7', 'Think Tank', null, '211', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000');
GO
SET IDENTITY_INSERT [organizationtype] OFF
GO

-- ----------------------------
-- Records of paymentstatustype
-- ----------------------------
SET IDENTITY_INSERT [paymentstatustype] ON
GO
INSERT INTO [paymentstatustype] ([id], [paymentstatusname], [paymentstatusdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('1', 'New', 'New', '2012-01-24 00:00:00.000', '211', '2012-01-24 00:00:00.000', '211');
INSERT INTO [paymentstatustype] ([id], [paymentstatusname], [paymentstatusdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('2', 'In Finance', 'In Finance', '2012-01-24 00:00:00.000', '211', '2012-01-24 00:00:00.000', '211');
INSERT INTO [paymentstatustype] ([id], [paymentstatusname], [paymentstatusdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('3', 'Awaiting Signature', 'Awaiting Signature', '2012-01-24 00:00:00.000', '211', '2012-01-24 00:00:00.000', '211');
INSERT INTO [paymentstatustype] ([id], [paymentstatusname], [paymentstatusdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('4', 'Pending Payment', 'Pending Payment', '2012-01-24 00:00:00.000', '211', '2012-01-24 00:00:00.000', '211');
INSERT INTO [paymentstatustype] ([id], [paymentstatusname], [paymentstatusdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('5', 'Paid', 'Paid', '2012-01-24 00:00:00.000', '211', '2012-01-24 00:00:00.000', '211');
INSERT INTO [paymentstatustype] ([id], [paymentstatusname], [paymentstatusdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('6', 'Cancel Requested', 'Cancel Requested', '2012-01-24 00:00:00.000', '211', '2012-01-24 00:00:00.000', '211');
INSERT INTO [paymentstatustype] ([id], [paymentstatusname], [paymentstatusdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('7', 'Rejected', 'Rejected', '2012-01-24 00:00:00.000', '211', '2012-01-24 00:00:00.000', '211');
INSERT INTO [paymentstatustype] ([id], [paymentstatusname], [paymentstatusdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('8', 'Cancelled', 'Cancelled', '2012-01-24 00:00:00.000', '211', '2012-01-24 00:00:00.000', '211');
INSERT INTO [paymentstatustype] ([id], [paymentstatusname], [paymentstatusdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('9', 'Resubmitted', 'Resubmitted', '2012-01-24 00:00:00.000', '211', '2012-01-24 00:00:00.000', '211');
GO
SET IDENTITY_INSERT [paymentstatustype] OFF
GO

-- ----------------------------
-- Records of paymenttype
-- ----------------------------
SET IDENTITY_INSERT [paymenttype] ON
GO
INSERT INTO [paymenttype] ([id], [paymenttypename], [paymenttypedesc], [createdate], [createdby], [lastupdated], [lastupdatedby], [status]) VALUES ('1', 'Advance', null, '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211', 'A');
INSERT INTO [paymenttype] ([id], [paymenttypename], [paymenttypedesc], [createdate], [createdby], [lastupdated], [lastupdatedby], [status]) VALUES ('2', 'Consultants/Contracts', null, '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211', 'A');
INSERT INTO [paymenttype] ([id], [paymenttypename], [paymenttypedesc], [createdate], [createdby], [lastupdated], [lastupdatedby], [status]) VALUES ('3', 'Partner Payment', null, '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211', 'A');
INSERT INTO [paymenttype] ([id], [paymenttypename], [paymenttypedesc], [createdate], [createdby], [lastupdated], [lastupdatedby], [status]) VALUES ('4', 'Staff Reimbursements', null, '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211', 'A');
INSERT INTO [paymenttype] ([id], [paymenttypename], [paymenttypedesc], [createdate], [createdby], [lastupdated], [lastupdatedby], [status]) VALUES ('5', 'Reclass/Liquidation', null, '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211', 'A');
INSERT INTO [paymenttype] ([id], [paymenttypename], [paymenttypedesc], [createdate], [createdby], [lastupdated], [lastupdatedby], [status]) VALUES ('6', 'Vendor Invoices', null, '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211', 'A');
INSERT INTO [paymenttype] ([id], [paymenttypename], [paymenttypedesc], [createdate], [createdby], [lastupdated], [lastupdatedby], [status]) VALUES ('7', 'GRANTEE PAYMENT REQUEST', null, '2012-01-03 00:00:00.000', '211', '2012-01-03 00:00:00.000', '211', null);
INSERT INTO [paymenttype] ([id], [paymenttypename], [paymenttypedesc], [createdate], [createdby], [lastupdated], [lastupdatedby], [status]) VALUES ('8', 'INVOICE', null, '2012-01-03 00:00:00.000', '211', '2012-01-03 00:00:00.000', '211', null);
INSERT INTO [paymenttype] ([id], [paymenttypename], [paymenttypedesc], [createdate], [createdby], [lastupdated], [lastupdatedby], [status]) VALUES ('9', 'MEMO', null, '2012-01-03 00:00:00.000', '211', '2012-01-03 00:00:00.000', '211', null);
INSERT INTO [paymenttype] ([id], [paymenttypename], [paymenttypedesc], [createdate], [createdby], [lastupdated], [lastupdatedby], [status]) VALUES ('10', 'MEMO/WIRE', null, '2012-01-03 00:00:00.000', '211', '2012-01-03 00:00:00.000', '211', null);
INSERT INTO [paymenttype] ([id], [paymenttypename], [paymenttypedesc], [createdate], [createdby], [lastupdated], [lastupdatedby], [status]) VALUES ('11', 'OTHER', null, '2012-01-03 00:00:00.000', '211', '2012-01-03 00:00:00.000', '211', null);
INSERT INTO [paymenttype] ([id], [paymenttypename], [paymenttypedesc], [createdate], [createdby], [lastupdated], [lastupdatedby], [status]) VALUES ('12', 'PAYMENT/REIMBURSEMENT REQUEST FORM', null, '2012-01-03 00:00:00.000', '211', '2012-01-03 00:00:00.000', '211', null);
INSERT INTO [paymenttype] ([id], [paymenttypename], [paymenttypedesc], [createdate], [createdby], [lastupdated], [lastupdatedby], [status]) VALUES ('13', 'PAYMENT/REIMBURSEMENT REQUEST FORM/WIRE', null, '2012-01-03 00:00:00.000', '211', '2012-01-03 00:00:00.000', '211', null);
INSERT INTO [paymenttype] ([id], [paymenttypename], [paymenttypedesc], [createdate], [createdby], [lastupdated], [lastupdatedby], [status]) VALUES ('14', 'PURCHASE ORDER', null, '2012-01-03 00:00:00.000', '211', '2012-01-03 00:00:00.000', '211', null);
INSERT INTO [paymenttype] ([id], [paymenttypename], [paymenttypedesc], [createdate], [createdby], [lastupdated], [lastupdatedby], [status]) VALUES ('15', 'PURCHASE ORDER/WIRE', null, '2012-01-03 00:00:00.000', '211', '2012-01-03 00:00:00.000', '211', null);
INSERT INTO [paymenttype] ([id], [paymenttypename], [paymenttypedesc], [createdate], [createdby], [lastupdated], [lastupdatedby], [status]) VALUES ('16', 'RECLASS', null, '2012-01-03 00:00:00.000', '211', '2012-01-03 00:00:00.000', '211', null);
INSERT INTO [paymenttype] ([id], [paymenttypename], [paymenttypedesc], [createdate], [createdby], [lastupdated], [lastupdatedby], [status]) VALUES ('17', 'RECLASSIFICATION OF PAYMENT REQUEST', null, '2012-01-03 00:00:00.000', '211', '2012-01-03 00:00:00.000', '211', null);
INSERT INTO [paymenttype] ([id], [paymenttypename], [paymenttypedesc], [createdate], [createdby], [lastupdated], [lastupdatedby], [status]) VALUES ('18', 'TRAVEL ADVANCE', null, '2012-01-03 00:00:00.000', '211', '2012-01-03 00:00:00.000', '211', null);
INSERT INTO [paymenttype] ([id], [paymenttypename], [paymenttypedesc], [createdate], [createdby], [lastupdated], [lastupdatedby], [status]) VALUES ('19', 'TRAVEL EXPENSE', null, '2012-01-03 00:00:00.000', '211', '2012-01-03 00:00:00.000', '211', null);
GO
SET IDENTITY_INSERT [paymenttype] OFF
GO

-- ----------------------------
-- Records of projectstatus
-- ----------------------------
SET IDENTITY_INSERT [projectstatus] ON
GO
INSERT INTO [projectstatus] ([id], [statusname], [statusdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('1', 'Active', 'CIPE has received signed grant agreement.  6790''s, 6791''s and 6795''s can be requested.', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211');
INSERT INTO [projectstatus] ([id], [statusname], [statusdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('2', 'Cancelled', 'Partner has canceled the project.  Can no longer be billed to.  Costs are kept.', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211');
INSERT INTO [projectstatus] ([id], [statusname], [statusdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('3', 'Closed', 'Project is closed and archived.  Fin.', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211');
INSERT INTO [projectstatus] ([id], [statusname], [statusdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('4', 'Over', 'Project end date has passed; payments may be booked for expenditures incurred during the period of the project; no time may be booked to the project after the end date.', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211');
INSERT INTO [projectstatus] ([id], [statusname], [statusdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('5', 'Pending', 'Project is in proposal stage.
Cannot be billed to for any reason.', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211');
INSERT INTO [projectstatus] ([id], [statusname], [statusdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('6', 'Terminated', 'CIPE has canceled the project.  Can no longer be billed to.  Costs are kept.', '2011-12-29 00:00:00.000', '211', '2011-12-29 00:00:00.000', '211');
GO
SET IDENTITY_INSERT [projectstatus] OFF
GO

-- ----------------------------
-- Records of projecttype
-- ----------------------------
SET IDENTITY_INSERT [projecttype] ON
GO
INSERT INTO [projecttype] ([id], [projecttype], [projectdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('30', 'Management', 'Management', '2012-01-19 11:47:02.000', '211', '2012-01-19 11:47:02.000', '211');
INSERT INTO [projecttype] ([id], [projecttype], [projectdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('31', 'Non-Partnered', 'Non-Partnered', '2012-01-19 11:47:02.000', '211', '2012-01-19 11:47:02.000', '211');
INSERT INTO [projecttype] ([id], [projecttype], [projectdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('32', 'Partner', 'Partner', '2012-01-19 11:47:02.000', '211', '2012-01-19 11:47:02.000', '211');
INSERT INTO [projecttype] ([id], [projecttype], [projectdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('33', 'Consultant', 'Consultant', '2012-01-19 11:47:02.000', '211', '2012-01-19 11:47:02.000', '211');
INSERT INTO [projecttype] ([id], [projecttype], [projectdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('34', 'Administration/Indirect', 'Administration/Indirect', '2012-01-19 11:47:02.000', '211', '2012-01-19 11:47:02.000', '211');
INSERT INTO [projecttype] ([id], [projecttype], [projectdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('35', 'Balance Sheet', 'Balance Sheet', '2012-01-19 11:47:02.000', '211', '2012-01-19 11:47:02.000', '211');
INSERT INTO [projecttype] ([id], [projecttype], [projectdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('36', 'Administration', 'Administration', '2012-01-19 11:47:02.000', '211', '2012-01-19 11:47:02.000', '211');
INSERT INTO [projecttype] ([id], [projecttype], [projectdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('37', 'CIPE Headquarters', 'CIPE Headquarters', '2012-01-19 11:47:02.000', '211', '2012-01-19 11:47:02.000', '211');
INSERT INTO [projecttype] ([id], [projecttype], [projectdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('38', 'CIPE Field Office', 'CIPE Field Office', '2012-01-19 11:47:02.000', '211', '2012-01-19 11:47:02.000', '211');
INSERT INTO [projecttype] ([id], [projecttype], [projectdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('39', 'Indirect', 'Indirect', '2012-01-19 11:47:02.000', '211', '2012-01-19 11:47:02.000', '211');
INSERT INTO [projecttype] ([id], [projecttype], [projectdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('40', 'Timesheet', 'Timesheet', '2012-01-19 11:47:02.000', '211', '2012-01-19 11:47:02.000', '211');
INSERT INTO [projecttype] ([id], [projecttype], [projectdesc], [createdate], [createdby], [lastupdated], [lastupdatedby]) VALUES ('41', 'Test ProjectType', 'Management', '2012-02-20 06:34:23.270', '12', '2012-03-24 03:45:25.300', '12');
GO
SET IDENTITY_INSERT [projecttype] OFF
GO